package com.sixuerain.heartkey.prayer.db.table;

public class UserTable implements TableBase {
	
	public static final String TAG = "UserTable";
	public static final String TABLE_NAME = "T_user";

	public static final String USERID = "id";
	public static final String USERNAME = "name";
	public static final String PASSWORD = "password";
	public static final String ATTRIBUTE1 = "attribute1";
	public static final String ATTRIBUTE2 = "attribute2";
	public static final String ATTRIBUTE3 = "attribute3";
	
	public static final String[] TABLE_COLUMNS_IDNAME = new String[] {USERID, USERNAME};
	public static final String[] TABLE_COLUMNS = 
			new String[] {USERID, USERNAME,PASSWORD,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3};

	public static final String CREATE_TABLE = 
	"create Table " + TABLE_NAME + "( " +
		  USERID + " integer primary key," +
		  USERNAME + " Nvarchar(100)," + 
		  PASSWORD + " Nvarchar(20)," +
		  ATTRIBUTE1 + " Nvarchar(20)," +
		  ATTRIBUTE2 + " Nvarchar(20)," +
		  ATTRIBUTE3 + " Nvarchar(20)" +
		");";  
}
